Cache Coherency Schemes for Fine-Grained Sharing in a Shared Disks Transaction Environment

Shared disks environment (SDE) refers to a distributed architecture for high performance transaction processing. In SDE, the computing nodes are locally coupled via a high-speed network and share a common database at the disk level. To avoid frequent disk accesses, each node caches database pages in its main memory buuer. However, since a particular page may be simultaneously cached in diierent nodes, cache consistency should be maintained to ensure that the nodes always see the most recent version of database pages. In this paper, we propose two cache coherency schemes for SDE with ne-granularity (e.g., record) locking. The proposed schemes improve the performance by alleviating the amount of message traac or by reducing the number of cache misses.